MySQLDatabase Class
Used to open MySQL databases.
Notes
In order to use this class, you must install the MySQL database plug-in in your plugins folder.
If the plug-in is installed, you can also open a MySQL database in the REALbasic IDE using the Project . Add . Database . SelectMySQLDatabase command. This command presents a dialog box that requests the server, port, database, Username, and Password properties.
The set of database plug-ins is included on the REALbasic CD, but you may find more recent versions at the REAL Software web site, http://www.realsoftware.com.
Example
This example establishes a connection to a remote database.
Dim db as mySQLDatabase
db= New mySQLDatabase
db.host="192.168.1.172"
db.port=3306
db.databaseName="MyOwnmySQLdatabase"
db.userName="Mary"
db.Password="Elton"
If db.Connect then
//proceed with database operations
else
MsgBox "Connection failed!"
end if
db= New mySQLDatabase
db.host="192.168.1.172"
db.port=3306
db.databaseName="MyOwnmySQLdatabase"
db.userName="Mary"
db.Password="Elton"
If db.Connect then
//proceed with database operations
else
MsgBox "Connection failed!"
end if
See Also